Partition Schemes

A partition scheme is a scheme in the current database that maps the rows of a table or index into partitions based on the values of a specified column. The number and domain of the partitions of a partitioned table or index are determined in a partition scheme.

Note: Support from SQL Server 2005 or later.

Just simply click -> Partition Scheme to open an object pane for Partition Scheme. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit and delete the selected partition scheme.

Create Partition Scheme

To create a new partition scheme

To create a new partition scheme with modification as one of the existing partition scheme

Edit Partition Scheme

To edit the existing partition scheme (manage its general etc)

To change the name of the partition scheme

Delete Partition Scheme

To delete a partition scheme

Achieve Partition Scheme Information

To achieve a partition scheme information